﻿CREATE TABLE [entity].[Person] (
    [PersonID]    INT          IDENTITY (1, 1) NOT NULL,
    [EntityID]    INT          NULL,
    [ImageID]     INT          NULL,
    [LastName]    VARCHAR (50) NULL,
    [FirstName]   VARCHAR (50) NULL,
    [MiddleName]  VARCHAR (50) NULL,
    [DateOfBirth] DATETIME     NULL,
    CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED ([PersonID] ASC),
    CONSTRAINT [FK_Person_Entity] FOREIGN KEY ([EntityID]) REFERENCES [entity].[Entity] ([EntityID]),
    CONSTRAINT [FK_Person_Image] FOREIGN KEY ([ImageID]) REFERENCES [core].[Image] ([ImageID])
);

